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?

 

AnkitBI's avatar
AnkitBI
Solution Sage
6 years ago

Hi ragoe 

 

If you meant Slicers then measures can't be used in Slicers. What you can try to do is a Calculated Column using 'COUNT('kwh 2018'[Dato])' and use in Slicer

 

Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.

 

 

  • ragoe's avatar
    ragoe
    Frequent Visitor
    6 years ago

    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".?

     

    • AnkitBI's avatar
      AnkitBI
      Solution Sage
      6 years ago

      Hi ragoe 

       

      Your requirement is not clear. Can you share some example of what are you trying to achieve and may be some better sample data.