Forum Discussion
Countrows as per slicer selection
Hi folks, I have a fact table which contains Student's details like below (attached sample copy), I'm trying to create a DAX expression that will enable me to return data when a student failed/pas...
Whitewater100
Solution Sage
Solution SageHI:
You can try (if you have marked and continuous date table linked to your data table):
= LASTNONBLANK(Table[exam status], CALCULATE(SUM(Table[StudentID])))
Usually I have sales info or some other number column and the final part would be CALCULATE(SUM(Product[sales]) - so I'm hoping this works even though it sounds a little weird.