Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I want help to create 1 measure which can do both work so I can put it on the table and be able to drill up and drill down
Hi,
I have 2 Dax Measures which normalize the data between 0 to 1 so I can use them to create row-based conditional formatting.
1st Measure normalizes the data for only Year and 2nd one normalizes data for only Quarters
I am attaching a .pbix file you can go through it to see my dax measures
Thanks
Power Bi File
https://www.dropbox.com/s/6lca1mcelm301tu/Power%20Bi%20Help.pbix?dl=0
DAX Measure Used for Normalizing Quaterly just Removed Quater from summary table and from allselected() to create yearly
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |