Forum Discussion
Solved
Calculated measure as a filter? (Energy meter validation)
Hi guys As a power bi newbie I have only attained a basic level of DAX and have hit a brick wall. I am trying to validate energy measurements and the idea is to have a filter for all my visua...
Hi ragoe ,
Please try the DAX below and create the calculated column.
no.day = CALCULATE(COUNT('kwh 2018'[Dato]),ALLEXCEPT('kwh 2018','kwh 2018'[Dato]))Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi AnkitBI
Yes of course, I mean slicer!
The problem is that if I do the calculated column I only get one option in the slicer? The total count of "Kwh".?
