Forum Discussion

Kamana's avatar
Kamana
New Member
3 years ago
Solved

How to Create Measure Based on Slicer Value?

Hello All,

I am quite new to Power BI. I want to create a measure that calculates month average of total amount. But it should display according to year selected from Slicer.

Summarizing the above statement:

If Year selected from Slicer = 2023, then condition A,

If not Condition B in measure.

Thanks in advance. 

  • hi Kamana 

    it is like:

    IF(
        SELECTEDVALUE(TableName[Year]) = 2023,
        condition A, condition B
    )

2 Replies

  • hi Kamana 

    it is like:

    IF(
        SELECTEDVALUE(TableName[Year]) = 2023,
        condition A, condition B
    )