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 have created a key measure condition to return true or false from my viz table.
Here is an example below, I have multiple rows, with the condition true or false and I am trying to calculate based on this condition what's the % of true by counting the rows, however I am facing some difficulties with the simple dax countrows.
Would be so nice to have your help on that, thank you!!
Product ID | Product Name | Market | application | sales CY | sales PY | Condi |
1452454 | tomatoes | store | tomato sauce | 1245 | 1235 | True |
1452454 | tomatoes | truck food | pizza | 4578 | False |
Solved! Go to Solution.
So I was able to find a solution for this issue, it might be helpful for some other BI users
I have used first
Instead of summing up the True/False measure, you could use that calculation in the sum.
Using your data, I made a simple [True/False] measure
Measure Condi = IF(SELECTEDVALUE('Table'[Market]) = "store", "True", "False")
count True rows = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Market]= "store"))
Percent true rows = DIVIDE(CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Market] = "store")),COUNTROWS('Table'))
Hi, thanks a lot for the prompt reply. That's a good way to do it, however the way how my data are this will not be possible because the condition is the one that could defferienciate between the product IDs if it is true or false, also it has to be dynamic otherwise drilling down and up I cannot get the %
I I have tried it this way, but I am stuck with counting the rows
So I was able to find a solution for this issue, it might be helpful for some other BI users
I have used first
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |