Forum Discussion

ragoe's avatar
ragoe
Frequent Visitor
6 years ago
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...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    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.

     

ragoe's avatar
ragoe
Frequent Visitor
6 years ago

Hi

 

I will try to clear up.

Sample:

 

My measure is 

Numberdays = COUNT('kwh 2018'[Dato])
 
I can set this into a table visual no problem, but I can not use this measure in a filter visual?

 

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago

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.