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 all
I created 8 dax function that returns the count of ocassions the "Government time" is within:
0 - 30 days
30 - 60 days
60 - 90 days
90 - 120 days
120 - 150 days
150 - 180 days
180 - 210 days
210 and above
Example for the 180-210 days
CALCULATE(
COUNT('Sanitary Registration Mass Report'[Cycle Time (Process)]),FILTER('Sanitary Registration Mass Report','Sanitary Registration Mass Report'[Cycle Time (Process)]>180&&'Sanitary Registration Mass Report'[Cycle Time (Process)]<=210)
)
This is kinda unefficient so I wanted to know if there is a way to have in a single dax function all this bunch of dax measures.
I attach PBIx.
https://1drv.ms/u/s!ApgeWwGTKtFdhiKPn67mXUs1txlw?e=8SvWVE
Thanks.
Solved! Go to Solution.
Hi
try this file https://ufile.io/whlx43iq
I added dimension table dimIntervals with all possible intervals and a calculated column in your table
You are welcome. If my previous reply helped, please mark that as Answer.
ABCD is just the title of the column. You may give any meaningful title within the double quotes.
Hi,
You may download my PBI file from here. I have only measures to solve this question.
Hope this helps.
You are welcome. If my previous reply helped, please mark that as Answer.
ABCD is just the title of the column. You may give any meaningful title within the double quotes.
Hi
try this file https://ufile.io/whlx43iq
I added dimension table dimIntervals with all possible intervals and a calculated column in your table
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |