Unpivoted Columns - Filtering with use of Measure or CC

[misiek5510]

Hi,

I have unpivoted multiple columns which where all values, however they are of mixed type. (Whole number, % , Decimals) 

Is there a way to get an value for a given attribute with use of measure or caluclated column? 

Attribute	Value
A	5
B	7
D	0.2
E	5.2

D = 20%

[misiek5510]

It worked great thanks 🙂 I've also used the below for a card visual. 🙂 

D Value = 
CALCULATE(SUM(Table[Value]), Table [Attribute] = "D"), LASTDATE(Table[Date].date))

[PaulDBrown · Accepted solution]

Try:

D Value = 
CALCULATE(SUM(Table[Value]), Table [Attribute] = "D")

and then format the measure as a %

[misiek5510]

Thank you so much 🙂 Could I possibly average the result it brings via MTD funciton somehow? (I have a column "DATE and if goes up in 7 day (week) intervals. 

[PaulDBrown]

It would help if you posted a sample of the data and the expected outcome

[misiek5510]

For Example:

Date	At.	Val.
1/1/2022	A	5
1/1/2022	B	0.2
7/1/2022	A	12
7/1/2022	B	0.4

B = 30% (Average based on two weeks in that month). 

[PaulDBrown]

Do you have a date table?

[PaulDBrown]

See if this works:

Aver. B Value = 
CALCULATE(AVERAGE('Table'[Val.]),'Table'[At.] = "B")

Ave. B Value By Month =
VAR MNTH =
    MONTH ( MAX ( 'Table'[Date] ) )
VAR _Calc =
    CALCULATE (
        [Aver. B Value],
        FILTER ( ALL ( 'Table' ), MONTH ( 'Table'[Date] ) = MNTH )
    )
RETURN
    IF ( AND ( MAX ( 'Table'[At.] ) = "B", ISINSCOPE ( 'Table'[At.] ) ), _Calc )

I've attached the sample PBIX file