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.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Not clear. Typically when you have the filter in calculate, it should filter your data in the visualization

Can you share sample data and sample output.

 

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?