Hi Experts,
I need help on how to count data that is resulted from a measure.
As per the below screenshot, I used the "Datadiff" function to get the numbers between 2 different dates "POR to Scopping" . Now i need to count how many "POR to scopping" that are more than 14 . The problem is that "POR to Scopping" is a measure and i can't get the "Count " function to work for measures and it only worke for columns!
Solved! Go to Solution.
Use COUNTX or COUNTROWS. Build a table using FILTER and perhaps ADDCOLUMNS that represents your table. Then use COUNTX against that table, perhaps with an additional filter for > 14. For example:
Measure Count = VAR __table = ALL('Table') VAR __table1 = ADDCOLUMNS(__table,"__MyMeasure",[Measure]) RETURN COUNTROWS(FILTER(__table1,[__MyMeasure] > 14))
Use COUNTX or COUNTROWS. Build a table using FILTER and perhaps ADDCOLUMNS that represents your table. Then use COUNTX against that table, perhaps with an additional filter for > 14. For example:
Measure Count = VAR __table = ALL('Table') VAR __table1 = ADDCOLUMNS(__table,"__MyMeasure",[Measure]) RETURN COUNTROWS(FILTER(__table1,[__MyMeasure] > 14))
HI Dreg,
Thanks for the feedback!
I got it working by using the below statment :
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
217 | |
57 | |
49 | |
46 | |
45 |
User | Count |
---|---|
268 | |
211 | |
113 | |
82 | |
71 |