Forum Discussion

Ormy28's avatar
Ormy28
Regular Visitor
1 year ago
Solved

Matrix Visual - Attributes on Different Rows

Hi   I have a table of transactions that includes a Start Date along with two attributes, Transaction Type and Fulfilled.   Transaction Type is simply a three letter code and Fulfilled is just a ...
Need Help
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi Ormy28 ,

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.

    Regards,

    Rama U.

Cookistador's avatar
Cookistador
Icon for Super User rankSuper User
1 year ago

Hi Ormy28 

The following dax measure should help you

Total =
VAR CountValue = CALCULATE(COUNT('Table'[Transaction Type]))+0
RETURN
IF(
        ISINSCOPE('Table'[Transaction Type]),
            CountValue,
            CALCULATE(COUNT('Table'[Fulfilled]),'Table'[Fulfilled] = 1)
)

 

 
Ormy28's avatar
Ormy28
Regular Visitor
1 year ago

Thanks for your reply.

 

How would you then use this measure? I was of the understanding that measures could not be used as rows in a matrix visual?