Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |