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.

PhilipTreacy's avatar
PhilipTreacy
Super User
4 years ago

Hi smather 

 

Download sample PBIX file

 

This measure works

 

Measure = 

VAR _x = CALCULATE(MINX('Table', [Date Time Start]), FILTER(ALL('Table'), 'Table'[Name] = MIN('Table'[Name])))
VAR _ac = MIN('Table'[Cat]) in {"a", "c"}

RETURN

SWITCH(

    TRUE(),

    _ac && (_x = MIN('Table'[Date Time Start])), 1,

    BLANK()
)

 

 

regards

 

Phil

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!