Exclude data from Semantic Models.

[dthompsonKairos]

I am working with the Power Bi service Report usage Semantic model.

I am trying to create a series of Cards like Most Viewed Report, and variations on that combined with the totasl views, user views, etc. and depend on Ranking.

The problem is that the highest ranked report in my smallish company is the power bi usage report I'm working on. I wish to exclude that from the report usage data metrics.

But, the data is all in a Semantic model. So I have no access to it via the Transform window where I would normally find and exclude a specific row.

This measure shows the most viewed report via the Report Rank table in the model. How can I modify this to exclude a specifc ReportID. I have the specific ID (GUID) value.

MostViewed =

   VAR MaxRankID =

         CALCULATE (

    VALUES ( 'Report rank'[ReportId] ),

    FILTER ( ALL ( 'Report rank'[ReportRank] ), 'Report rank'[ReportRank] = MAX ( 'Report rank'[ReportRank] )  )

         )

   RETURN

         lookupvalue('Reports'[ReportName],'Reports'[ReportGuid],MaxRankID)

Thx

[AlexisOlson · Accepted solution]

You can add a step to get the max excluding your GUID.

MostViewed =
VAR ExcludeID = "Your_GUID_Here"
VAR MaxRank =
    CALCULATE (
        MAX ( 'Report rank'[ReportRank] ),
        ALL ( 'Report rank' ),
        'Report rank'[ReportId] <> ExcludeID
    )
VAR MaxRankID =
    CALCULATE (
        VALUES ( 'Report rank'[ReportId] ),
        ALL ( 'Report rank' ),
        'Report rank'[ReportRank] = MaxRank
    )
RETURN
    LOOKUPVALUE ( 'Reports'[ReportName], 'Reports'[ReportGuid], MaxRankID )

Alternatively, you can filter the GUI out at the report level and try ALLSELECTED instead of ALL in your measure.