topic Re: all measure in Desktop

all measure

Anonymous — Tue, 08 Mar 2022 06:39:25 GMT

Hi there,

I need a column chart to show accident by year, and a multi-row card to show the number of selected year.

Please advise how to write the measure. Thank you

Here is my data

amitchandak — Tue, 08 Mar 2022 07:20:01 GMT

@Anonymous ,

You can use year from date hierarchy

year = year([Date])

Use that on axis

Catrgory legend

and Sum(Table[Number])+0 , measure on values

Multi-row car you should build on category , it should filter selected year

if you want slicer not to filter stop interactions

v-angzheng-msft — Fri, 11 Mar 2022 05:30:54 GMT

Hi, @Anonymous

Try to create measures like this:

cat1 = CALCULATE(SUM('Table1'[Number]),FILTER(ALLSELECTED(Table1),'Table1'[Category]="Fatal Accident"))

cat2 = CALCULATE(SUM('Table1'[Number]),FILTER(ALLSELECTED(Table1),'Table1'[Category]="lnjury w/o Lost Time Accident"))

cat3 = CALCULATE(SUM('Table1'[Number]),FILTER(ALLSELECTED(Table1),'Table1'[Category]="Lost Time Accident"))

Result:

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.