Forum Discussion

MadisMerk's avatar
MadisMerk
Helper I
7 years ago
Solved

Measure question

Can you help me with a measure? Let us imagine I have this table as a starting point Vehicle number Customer name Vehicle type Amount 550 RLA Toomas New 1 885 ASS ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    MadisMerk 

     

    Try this MEASURE

     

    Measure =
IF (
    COUNTROWS ( VALUES ( TableName[Vehicle type] ) ) = 1
        && CALCULATE (
            DISTINCTCOUNT ( TableName[Vehicle type] ),
            TableName[Vehicle type] = "Used"
        ) = 1,
    COUNT ( TableName[Vehicle type] )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

MadisMerk 

 

Try this MEASURE

 

Measure =
IF (
    COUNTROWS ( VALUES ( TableName[Vehicle type] ) ) = 1
        && CALCULATE (
            DISTINCTCOUNT ( TableName[Vehicle type] ),
            TableName[Vehicle type] = "Used"
        ) = 1,
    COUNT ( TableName[Vehicle type] )
)