Forum Discussion

Veles's avatar
Veles
Icon for Advocate V rankAdvocate V
9 years ago

Table not showing all items but total is correct - variable measure

I've got a report page on financial data by site that users can slice and dice using a few slicers.   The matrix (new version) has Actual and Comparator columns - these are both measures - and a si...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Veles

 

Could you post the results from your measures in table format? And also are you aware of the YTD, QTD and MTD functions in DAX in Power BI?

  • Veles's avatar
    Veles
    Icon for Advocate V rankAdvocate V
    9 years ago

    Hi Anonymous

     

    My period is not actually in month format (P01, P02,...,P12) so the YTD, QTD, MTD quick measures don't work.

     

    Table looks like this:

     

    Region	Sub-Region	Name	Actual	Comparator
Region	Sub-Region	Site 1	-133936	-113399
Region	Sub-Region	Site 2	4913	8414
Region	Sub-Region	Site 3	176411	114427
			Total	170186	9442

    But should look like this:

     

    Region	Sub-Region	Name	Actual	Budget
Region	Sub-Region	Site 1	-133936	-113399
Region	Sub-Region	Site 4	-387	
Region	Sub-Region	Site 5	-52	
Region	Sub-Region	Site 6	-13	
Region	Sub-Region	Site 7	14	
Region	Sub-Region	Site 8	168	
Region	Sub-Region	Site 9	3751	
Region	Sub-Region	Site 2	4913	8414
Region	Sub-Region	Site 10	5453	
Region	Sub-Region	Site 11	7192	
Region	Sub-Region	Site 12	12008	
Region	Sub-Region	Site 13	12603	
Region	Sub-Region	Site 14	82061	
Region	Sub-Region	Site 3	176411	114427
		Total	170186	9442

    Even though the totals aren't being affected by my scenario slicer, the individual lines that are pulling through are.

     

    If I take out the Comparator measure and Scenario slicer and just use a measure for Budget that is constructed in the same way as Actual (just flitereing on the Budget scenario instead) the table works perfectly fine.