Forum Discussion
Solved
Power BI measure Total issue
Hi everyone, I need help creating a measure in power bi for a matrix table that's categorized by brand and store. It has three columns the first one contatins the number of found products in the sto...
Thank you both!
This was the correct answer at the end:Teljesülés =SUMX (SUMMARIZE('FACT_Jelenlét','DIM_Bolttörzs'[Bolt kód], 'FACT_Jelenlét Márka'[Márka] ),VAR Found = [Cikkek száma]VAR Required = [SUM_Elvárt jelenlét]RETURNIF (NOT ISBLANK ( Found ) && Found >= Required,1, 0 ))
Shahid12523
Community Champion
Community Championuse this
Teljesülés =
SUMX (
VALUES ( 'FACT_Jelenlét Márka'[Bolt kód] ),
VAR Found = CALCULATE ( [Cikkek száma] )
VAR Required = CALCULATE ( [SUM_Elvárt jelenlét] )
RETURN
IF (
NOT ISBLANK ( Found ) && Found >= Required,
1,
0
)
)