Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello!
I have to create many (nearly identical) DAX measures that work in the same way, but will change as they are created to apply to a series of different columns. My current process is just to copy and paste the template formula and change the column names accordingly. This is a bit tedious though.
I was thinking it would be nice if users could design their own Quick Measure to add to those offered in Power BI desktop. If anyone knows of a way to do this or to otherwise quickly create very similar measures, please let me know!
For reference my calculation goes generally like this:
Measure = (CALCULATE(SUM(Table1[Column1]), FILTER(Table1,Table1[Column2]="x"))) / (CALCULATE(SUM(Table1[Column1]), FILTER(Table1,Table1[Column2]<> BLANK() )))
Each time, for varying purposes, I have to change "Column2", and/or "x", and/or "Table1".
The closest thing that Quick Measures has would be the "Division" quick measure, but doesn't quite work because of the filters.
If anyone knows of a way to automate or otherwise very quickly create very similar measures, please let me know!
Thank you!
This is probably not what you want. But an idea.
You could have everthing in the one measure then using a "select" statement determine which version of measure you want.
Its not a great way as it can get a little confusing when using the measure.
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |