Forum Discussion

admin_xlsior's avatar
admin_xlsior
Icon for Post Prodigy rankPost Prodigy
7 years ago

Need help with a measure

Hello everyone,   Need help or advice on createing some measure. So I have this table: Sales Order Id ProcessDate SO001 1/1/2019 SO001 1/2/2019 SO001 1/3/2019 SO001 1/4/2019 ...
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi admin_xlsior ,

 

1. Create a new column 

Category = IF(CALCULATE(COUNT('Table'[Sales Order Id]),ALLEXCEPT('Table','Table'[Sales Order Id]))>5,">5","<5")

2. Add a visual (a chart, table, .. any kind you want your data to be displayed)

3. Add the category and the count of "Sales Order Id" to the visual.

 

Tell me if you have any problems ! 

 

Regards, 

Etienne

  • admin_xlsior's avatar
    admin_xlsior
    Icon for Post Prodigy rankPost Prodigy
    7 years ago

    Hi Ettiene,

     

    I cannot use CALCULATE in my new column. Maybe because I'm using "Direct query" ?

     

    Can we use Measure instead ?

     

    And forgot to mention, the visual I plan to use is Card or KPI.

     

     

    Thanks,