Forum Discussion

szmaya's avatar
szmaya
New Member
1 year ago
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...
Need Help
  • szmaya's avatar
    szmaya
    1 year ago

    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]
    RETURN
    IF (
    NOT ISBLANK ( Found ) && Found >= Required,
    1, 0 )
    )
anmolmalviya05's avatar
anmolmalviya05
Icon for Super User rankSuper User
1 year ago

Hi szmaya, Hope you are doing good!

Please try the below measure:

Teljesülés =
SUMX (
VALUES ( 'FACT_Jelenlét Márka'[Store] ),
VAR Found = [Cikkek száma]
VAR Required = [SUM_Elvárt jelenlét]
RETURN
IF ( NOT ISBLANK ( Found ) && Found >= Required, 1, 0 )
)


If this post helps to answer your question, please consider accepting it as a solution so others can find it more quickly when they face a similar challenge.




Proud to be a Microsoft Fabric community super user




Let's Connect on LinkedIn




Subscribe to my YouTube channel for Microsoft Fabric and Power BI updates.