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 a measure which counts the number or rows in a table, depending on a condition e.g.
COUNTX(
TableA,
IF(
AND(
TableA[Start Date] <= [Month End],
ISBLANK(TableA[End Date]) || TableA[End Date] >= [Month Start]
),
TableA[ID]
)
)
These results are then shown on a line graph, with month on the x axis.
I would like to visualise the rows that have been counted in a table, so I can see further details on the counted rows.
Drill though does not work because the rows counted for a specific month do not necessarily fall within that month.
Does anyone have any suggestions?
Thanks!
Solved! Go to Solution.
Create a new measure like
Is Visible = IF(
SELECTEDVALUE('TableA'[Start Date]) <= [Month End] &&
( SELECTEDVALUE('TableA'[End Date]) >= [Month Start] || ISBLANK(SELECTEDVALUE('TableA'[End Date])),
1)
then use that as a filter on your table visual to only show rows when the value is 1
Hi, I tried your suggestion out. I can't get it to work as a filter. But if I put the new measure in a table along with the other fields I want to see, it seems to work ok then. I'm not too sure why that is... but anyway, it's better than I had before, so thanks.
Hi johnt75,
Thanks for the response. I'll have a look into this. Will let you know how I get on.
Create a new measure like
Is Visible = IF(
SELECTEDVALUE('TableA'[Start Date]) <= [Month End] &&
( SELECTEDVALUE('TableA'[End Date]) >= [Month Start] || ISBLANK(SELECTEDVALUE('TableA'[End Date])),
1)
then use that as a filter on your table visual to only show rows when the value is 1
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 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |