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 visuals that filters on wheter there are 365 measurements over 1 year per site.

 

My dataset is like: Siteno, Date, Kwh

 

I can create a measure that can be fileted in a table visual - Count(Kwh) And filter = 365 in the visual, but I can not create a calculated table that gives me the possibility to create a filter visual?

 

Help will be much appriciated. 

 

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.

     

6 Replies

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

       

      • AnkitBI's avatar
        AnkitBI
        Icon for Solution Sage rankSolution 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.