Forum Discussion

smather's avatar
smather
Helper III
4 years ago
Solved

Measure Help - VAR Formula

I need to do a measure and I'm a lil stuck on the best way to go about it.    Each person logs what they do in a day, and each person can have several entries per day. I need a VAR to assign 1 for ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, smather ;

    In your data, here is "a." and "c." ;not "a", "c".

    so you should change the measure.

    MyMeasure = 
CALCULATE(DISTINCTCOUNT('Table'[Full Name]), 'Table'[Cat] in {"a.", "c."})

    The final output is shown below:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

smather's avatar
smather
Helper III
4 years ago

Hi PhilipTreacy 

 

I've tried your VAR, and JirkaZ's formula below, but I don't get anything. I just have a blank box. There are filters on the page (to remove breaks/lunch) but even if I remove them, nothing happens 😞 

 

Would it be benifical to share dummy data PBIX?  

PhilipTreacy's avatar
PhilipTreacy
Super User
4 years ago

Hi smather 

 

Yes please, it's always beneficial to share the data/file you are working on so we are all working with the same data.

 

Regards

 

Phil

  • smather's avatar
    smather
    Helper III
    4 years ago

    Hi PhilipTreacy 

     

    See link below. I've removed most identifying information, but the underlying data is what I'm essentially working with. 

     

    PBIX Report 

     

    Thank you, I appreciate this!