Percentage Between 2 Filtered Values

[Bobbo]

Hello, I need to calculate the % difference from two card visuals, each have filtered values. I would like to display the % in a new Card visual.

'DimPolicy'[PolicyDateCreated] is the table and variable representing subscriptions. I have a Card visual for date ranges in 2020 and a Card visual for date ranges in 2019. On a side note, I need to do this on a month by month comparison year over year as well as full year comparisons for 2020 and 2019.

Could I use something like this? 

Count of PolicyNumber % difference from Count of PolicyNumber =

VAR __BASELINE_VALUE = COUNTA('DimPolicy'[PolicyNumber]) , (DATESINPERIOD ('DimPolicy'[PolicyDateCreated], DATE (2019,1,9), DATE (2019,30,9) ))

VAR __VALUE_TO_COMPARE = COUNTA('DimPolicy'[PolicyNumber]) , (DATESINPERIOD ('DimPolicy'[PolicyDateCreated], DATE (2020,1,9), DATE (2020,30,9) ))

RETURN

    IF(

        NOT ISBLANK(__VALUE_TO_COMPARE),

        DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)

    )

Thanks.

[v-shex-msft]

Hi @Bobbo,

Did these card visual filters are used the same data source field? If this is a case, you can't compare the difference based on same filter. (current you can't extract different values from files with the same data source field)
You need to duplicate that field to create a new table as a source of one filter, then you can compare the difference between two filters.

Regards,

Xiaoxin Sheng

[MFelix]

Hi @Bobbo ,

Don't know how your model looks like but the syntax seems fine, however if you want to have something more dinamic you need to change the filter part of your measure from a static values of date to something that picks up your values.

Can you please share a mockup data or sample of your PBIX file and expected result. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.