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.
Hello everyone,
I'm currently working on a tricky report that works but has a terrible performance. Now I hope to get some advice from the community what I could do better.
I am using a chiclet slicer that lets you click on 4 seperate buttons. Each buttons stand for one digit. The digits are 1, 5, 7, 9. You click on each button to choose your own combination.
I have a measure that sums up that digits to have a combination number.
DAX Flag Funktion = SUM(ProcessCategory[ProcessDigit])
That number is used to filter on a table if that number matches the one in table in a specific column.
check measure = IF(IF(ISERROR(FIND([DAX Flag Funktion];SELECTEDVALUE(Funktion[FunktionMatch])));0;SELECTEDVALUE(Funktion[FunktionMatch]))/[DAX Flag Funktion]=1;1;0)
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
32 | |
30 | |
18 | |
18 |