The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
13 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
24 | |
14 | |
13 | |
8 | |
8 |