Open Side Menu
Skip to contentBrand Logo
Forums
Inspiration
Ideas
Communities
Blogs
Learning
Support
RegisterSign In
  1. Microsoft Fabric Community
  2. Power BI forums
  3. Galleries
  4. Quick Measures Gallery
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Measure Totals, The Final Word

With apologies to Theodor Geisel...   Measure totals have you perturbed? Fear not! It's Measure Totals, The Final Word,   These measures work with matrices, They work with tables, They wo...
Measure Totals The Final Word.pbix52 KB
Featured
Mathematical
Totals
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous - So that looks like your m_Single measure. You would need an m_Total measure like the following:

 

m_Total = 
VAR __table = SUMMARIZE('Table',[Venue],"__value",[Utilization])
RETURN
IF(HASONEVALUE(Table[Venue]),[Utilization],SUMX(__table,[__value]))

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago


hi Greg_Deckler,
|there is no change in the result. still I am not getting 100% there are no filters applied.

 

  • © 2026 Microsoft
  • Manage cookies
  • Privacy & cookies
  • Terms of use
  • Trademarks
Your Privacy Choices Consumer Health Privacy