Goal: Produce the required calculated industries to alter “OR” so you can “AND” reasoning to have Electricity BI slicers (native slicer and hierarchySlicer).
I’ve been having fun with Stamina BI getting six months today. Eg early in the day BI products I have tried personally, a few cheats assist to transform apparently impossible organization conditions for the extremely happy reactions:
A couple of months ago, I was questioned adjust the latest reason within this a personalized graphic, the fresh new hierarchySlicer, off proving studies predicated on “OR” logic so you’re able to indicating investigation based on “AND” logic. Immediately after some research and many attempts, I’m delighted one to that the needed cheat is known!
Credit the words out of Deprive Collie: The greater number of you select, more you “get”. Since you find alot more contents of your own slicer, Energy BI shows the union of one’s research or even the type of a number of issues fulfilled of the deciding on the slicer activities. With every most slicer product picked, the total items of analysis chopped expands.
Long lasting business specifications might possibly be, at the end of a single day you want to figure out which people in the a group have preferred keeps. We need to would a keen intersection of analysis. Therefore can you imagine that we have always been looking for understanding hence countries’ flags act like both based on colour and you can facts. We shall establish that it which have one or two different Power BI slicers:
When the belongings in the brand new slicer was indeed chose in addition to number of issues picked into the slicer is equal to how many picked details getting a nation, reveal the fresh places
- Native slicer
- hierarchySlicer
I wish to become clear about how exactly the information and knowledge is actually structured getting replicating this method. I restructured UCI’s Flags Study Place to the one or two different dining tables, one carrying the nation pointers (countryInfo) plus the most other holding new banner information (flagInfo). countryInfo’s prie of the country and you may very important metrics such as for instance town, population, language, etc. inhabit it dining table. Brand new varying and detail flag information is a good hierarchical structure, and this lives in flagInfo. countryInfo and flagInfo provides a one to several dating into the term of the nation. When recurring so it to suit your analysis put, establish the same design to make certain right results.
In the event that items in the latest slicer were chose therefore the amount of situations chose to your slicer was comparable to the amount of chosen parameters to own a country, show the fresh regions
- Matters the number of issues picked from the slicer
Description: In the event that zero situations had been chose from the slicer, let you know every regions. In the event the items in this new slicer was indeed chose and level of situations picked on slicer is actually comparable to the amount of picked color to own a country, reveal the https://datingmentor.org/tr/kadin-secim-tarihleme/ fresh countries.
Description: Filter the country desk merely in which PBISlicer Glance at is valid. Towards blocked dining table, amount the latest rows of desk.
When creating the genuine dash, you should make certain brand new slicer’s “AND” reasoning consequences all the dashboard photos.
What is very important to notice because of it example is that i enjoys several tiered reasoning within the steps. On top peak, And you can logic is applicable (web browser. Need countries’ flags where info are symbol Or info is actually household). We’ll would five computed strategies that may what you should do:
When the contents of the fresh new slicer was indeed chose as well as the level of factors chosen into the slicer is actually equal to just how many chosen parameters getting a country, reveal the new nations
- Counts how many affairs selected on the slicer
Description: Filter out the country table simply in which HierarchySlicer See is true. For the filtered dining table, amount the latest rows of your own dining table.
Description: Filter the country desk merely where HierarchySlicer Check holds true. Into filtered table, assess the total people.
When making the real dash, you will want to make sure that the new slicer’s “AND” reason effects all dashboard pictures. Relate to these circumstances to help make the last credit and you will desk visualizations.
- I’d not recommend that have several ‘AND’ reason slicers for a passing fancy dashboard, obviously the reasoning into the ‘Check’ DAX computations becomes really difficult very fast.
- And additionally, I would not endorse which have several ‘AND’ reason slicers on a single dashboard as this can cause less than perfect results once i got found while using the dos ‘AND’ reasoning hierarchySlicers in identical dashboard.
- Create numerous quality-control on your own research efficiency!
Need countries’ flags in which you will find facts And you can band), when you find yourself towards the bottom top, Or reasoning applies (web browser
There are many different ways that you can use the brand new ‘AND’ reasoning DAX equations (web browser. using parameters, damaging the calculations right up far more, an such like.). This is basically the method you to worked for me personally and you can scaled well from inside the design. The information and knowledge, analysis restructuring code, and PBIX document on the blog post exists here. When you yourself have any questions or thoughts on the fresh course, feel free to reach regarding comments less than or courtesy Twitter. And additionally, if you prefer to learn more about Seismic Application and you can exactly how we use Microsoft’s Strength BI, check us out.