Forum Discussion
Isolate measure from graph category
- 5 years ago
Hi all,
First of all thank you for your your replies and the time you put into my challenge!
I did not came directly to the solution using yourt input on my challenge. In fact I was a bit overwhelmed by the complexity of especially the references to hierachies and INSCOPE functions.
After a lot of searching and reading through a lot more of complex solution, I found a solution very deas imple as I was expected it to be.
First I created the following formula:
#ShipmentsAllMethods = Calculate(Sum('table1'[Shipments]), ALL('table1'[Shipment_method])
Then I created a conditional data color formatting, where if the value is between 0-30 light pink, when value > 30 white.
I did the same for creating graphs with other categories like payment_method or shipment_country.
Hope this simple solution will help others with the same problem.
Again, many thanks guys!
Tjeerd , refer this can help
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/