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.
I want to write a measure to get a title which will show the no.of rows visible in the table after applying the filters.
For reference:
In the pic, no of document IDs that have [A_regFormat] = "EU" are 27 and [A_regFormat] = "Other" are 173 after the other applied 'filter on pages' (status, Product status in.., A_GHS)
I want to show the title as ...SDS (27 to 173...)...
How do I write the measure to acheive this?
Thanks.
Solved! Go to Solution.
"SDS(" &Calculate(Countrows(Table you are using to feed the visual), [A_regFormat] = "EU") & "to " & Calculate(Countrows(Table you are using to feed the visual), [A_regFormat] = "Other")&")"
"SDS(" &Calculate(Countrows(Table you are using to feed the visual), [A_regFormat] = "EU") & "to " & Calculate(Countrows(Table you are using to feed the visual), [A_regFormat] = "Other")&")"
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 |
---|---|
96 | |
93 | |
83 | |
70 | |
65 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |