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
Super 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?

 

  • 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.

         

  • V-lianl-msft's avatar
    V-lianl-msft
    Community 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.