Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I am a beginner in Power BI and I would like to know the feasibility/solution for my Queries.
For a given data table "Prototype Modeling_freight" I have a measure as:
volume = SUMX('Prototype Modeling_Freight', 'Prototype Modeling_Freight'[Sold Cases])
this converted to percentage for each type of equipment as:
Volume distribution = DIVIDE([volume],CALCULATE([volume],ALL('Prototype Modeling_Freight'))),0)
And visualized as clustered column chart
Now there are specifically two things I want this chart to do:
when I filter out through a date sclicer my chart must compare the data only within those sclicers, (note these sclicers can be other than dates)
Eg:
If you consider the Y axis in above picture, I want them to present 100%, or 'what was 25N's contribution in June month?'.
Thank you
Solved! Go to Solution.
Hi @Parthsh93
Try this instead
Volume distribution = DIVIDE([volume],CALCULATE([volume],ALLSELECTED())),0)
Hi @Parthsh93
Try this instead
Volume distribution = DIVIDE([volume],CALCULATE([volume],ALLSELECTED())),0)
Thank you @Mariusz, it worked. I would like to understand how is this happening?
Hi @Parthsh93
Sure, ALL() removes all filters from the filter context where ALLSELECTED() only the current one ie current visuals filters preserving all other filters coming from outside.
For more info please refer.
https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/
Thank You,
But the article you have suggested is too complex to understand and time consuming.
I need simpler definition.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
40 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |