Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have card visuals that show the total amount of toys, cars, cats and houses. I am slicing this data by date. if a date is not selected in the slicer I would like the default value of the card visual to be 0. If a date is selected then the appropriate filtering should flow through. Is there a measure that can help me accomplish this?
Solved! Go to Solution.
Hi, @dw700d
You can try the following methods.
Sample data:
SUM = SUM('Table'[Value])
Measure = IF(ISFILTERED('Table'[Date]),[SUM],0)
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @dw700d
You can try the following methods.
Sample data:
SUM = SUM('Table'[Value])
Measure = IF(ISFILTERED('Table'[Date]),[SUM],0)
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |